﻿CREATE TABLE [dbo].[HomePageData]
(
	[Id] INT NOT NULL PRIMARY KEY, 
    [SumDate] DATE NULL, 
    [SumType] INT NULL, 
    [SumValue] INT NULL
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'统计日期',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'HomePageData',
    @level2type = N'COLUMN',
    @level2name = N'SumDate'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'数据类型,0 新增 1 移除 2 电压告警 3 电流告警 4 温度告警 5 湿度告警 6 维护数 7 离线数 8 正常数',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'HomePageData',
    @level2type = N'COLUMN',
    @level2name = N'SumType'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'数据值',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'HomePageData',
    @level2type = N'COLUMN',
    @level2name = N'SumValue'